tab_mainline_nuclear_load_dt table jms_dm.dm_sqs_project_customer_summary_dt
    set tblproperties ('external.table.purge' = 'true');
drop table jms_dm.dm_sqs_project_customer_summary_dt;
CREATE EXTERNAL TABLE jms_dm.dm_sqs_project_customer_summary_dt
(
    project_first_type_code  string comment '项目一级编码',
    project_first_type_name  string comment '项目一级名称',
    project_second_type_name string comment '项目二级名称',
    customer_code            string comment '客户编码',
    customer_name            string comment '客户名称',
    taking_num               int comment '揽收量',
    complaint_num            int comment '客诉量',
    sham_num                 int comment '虚假签收量',
    delay_num                int comment '延误量',
    worn_num                 int comment '破损量',
    date_time                string comment '录入时间'
) COMMENT '平台项目指标达成报表'
    PARTITIONED BY (
        dt string COMMENT '订单录入日期')
    STORED AS PARQUET
    LOCATION '/dw/hive/jms_dm.db/external/dm_sqs_project_customer_summary_dt'
;
